package com.chengyu.core.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TyOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TyOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }


    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIsNull() {
            addCriterion("pay_order_no is null");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIsNotNull() {
            addCriterion("pay_order_no is not null");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoEqualTo(String value) {
            addCriterion("pay_order_no =", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotEqualTo(String value) {
            addCriterion("pay_order_no <>", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoGreaterThan(String value) {
            addCriterion("pay_order_no >", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("pay_order_no >=", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLessThan(String value) {
            addCriterion("pay_order_no <", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLessThanOrEqualTo(String value) {
            addCriterion("pay_order_no <=", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLike(String value) {
            addCriterion("pay_order_no like", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotLike(String value) {
            addCriterion("pay_order_no not like", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIn(List<String> values) {
            addCriterion("pay_order_no in", values, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotIn(List<String> values) {
            addCriterion("pay_order_no not in", values, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoBetween(String value1, String value2) {
            addCriterion("pay_order_no between", value1, value2, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotBetween(String value1, String value2) {
            addCriterion("pay_order_no not between", value1, value2, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(Integer value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(Integer value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(Integer value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(Integer value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(Integer value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<Integer> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<Integer> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(Integer value1, Integer value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(Integer value1, Integer value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNull() {
            addCriterion("member_name is null");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNotNull() {
            addCriterion("member_name is not null");
            return (Criteria) this;
        }

        public Criteria andMemberNameEqualTo(String value) {
            addCriterion("member_name =", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotEqualTo(String value) {
            addCriterion("member_name <>", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThan(String value) {
            addCriterion("member_name >", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("member_name >=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThan(String value) {
            addCriterion("member_name <", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThanOrEqualTo(String value) {
            addCriterion("member_name <=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLike(String value) {
            addCriterion("member_name like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotLike(String value) {
            addCriterion("member_name not like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameIn(List<String> values) {
            addCriterion("member_name in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotIn(List<String> values) {
            addCriterion("member_name not in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameBetween(String value1, String value2) {
            addCriterion("member_name between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotBetween(String value1, String value2) {
            addCriterion("member_name not between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameIsNull() {
            addCriterion("member_nickname is null");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameIsNotNull() {
            addCriterion("member_nickname is not null");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameEqualTo(String value) {
            addCriterion("member_nickname =", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameNotEqualTo(String value) {
            addCriterion("member_nickname <>", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameGreaterThan(String value) {
            addCriterion("member_nickname >", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("member_nickname >=", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameLessThan(String value) {
            addCriterion("member_nickname <", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameLessThanOrEqualTo(String value) {
            addCriterion("member_nickname <=", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameLike(String value) {
            addCriterion("member_nickname like", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameNotLike(String value) {
            addCriterion("member_nickname not like", value, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameIn(List<String> values) {
            addCriterion("member_nickname in", values, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameNotIn(List<String> values) {
            addCriterion("member_nickname not in", values, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameBetween(String value1, String value2) {
            addCriterion("member_nickname between", value1, value2, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberNicknameNotBetween(String value1, String value2) {
            addCriterion("member_nickname not between", value1, value2, "memberNickname");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgIsNull() {
            addCriterion("member_head_img is null");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgIsNotNull() {
            addCriterion("member_head_img is not null");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgEqualTo(String value) {
            addCriterion("member_head_img =", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgNotEqualTo(String value) {
            addCriterion("member_head_img <>", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgGreaterThan(String value) {
            addCriterion("member_head_img >", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgGreaterThanOrEqualTo(String value) {
            addCriterion("member_head_img >=", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgLessThan(String value) {
            addCriterion("member_head_img <", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgLessThanOrEqualTo(String value) {
            addCriterion("member_head_img <=", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgLike(String value) {
            addCriterion("member_head_img like", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgNotLike(String value) {
            addCriterion("member_head_img not like", value, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgIn(List<String> values) {
            addCriterion("member_head_img in", values, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgNotIn(List<String> values) {
            addCriterion("member_head_img not in", values, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgBetween(String value1, String value2) {
            addCriterion("member_head_img between", value1, value2, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMemberHeadImgNotBetween(String value1, String value2) {
            addCriterion("member_head_img not between", value1, value2, "memberHeadImg");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdIsNull() {
            addCriterion("mer_member_id is null");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdIsNotNull() {
            addCriterion("mer_member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdEqualTo(Integer value) {
            addCriterion("mer_member_id =", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdNotEqualTo(Integer value) {
            addCriterion("mer_member_id <>", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdGreaterThan(Integer value) {
            addCriterion("mer_member_id >", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mer_member_id >=", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdLessThan(Integer value) {
            addCriterion("mer_member_id <", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdLessThanOrEqualTo(Integer value) {
            addCriterion("mer_member_id <=", value, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdIn(List<Integer> values) {
            addCriterion("mer_member_id in", values, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdNotIn(List<Integer> values) {
            addCriterion("mer_member_id not in", values, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdBetween(Integer value1, Integer value2) {
            addCriterion("mer_member_id between", value1, value2, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andMerMemberIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mer_member_id not between", value1, value2, "merMemberId");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNull() {
            addCriterion("shop_id is null");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNotNull() {
            addCriterion("shop_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopIdEqualTo(Integer value) {
            addCriterion("shop_id =", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotEqualTo(Integer value) {
            addCriterion("shop_id <>", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThan(Integer value) {
            addCriterion("shop_id >", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("shop_id >=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThan(Integer value) {
            addCriterion("shop_id <", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThanOrEqualTo(Integer value) {
            addCriterion("shop_id <=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdIn(List<Integer> values) {
            addCriterion("shop_id in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotIn(List<Integer> values) {
            addCriterion("shop_id not in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdBetween(Integer value1, Integer value2) {
            addCriterion("shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotBetween(Integer value1, Integer value2) {
            addCriterion("shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopLogoIsNull() {
            addCriterion("shop_logo is null");
            return (Criteria) this;
        }

        public Criteria andShopLogoIsNotNull() {
            addCriterion("shop_logo is not null");
            return (Criteria) this;
        }

        public Criteria andShopLogoEqualTo(String value) {
            addCriterion("shop_logo =", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoNotEqualTo(String value) {
            addCriterion("shop_logo <>", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoGreaterThan(String value) {
            addCriterion("shop_logo >", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoGreaterThanOrEqualTo(String value) {
            addCriterion("shop_logo >=", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoLessThan(String value) {
            addCriterion("shop_logo <", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoLessThanOrEqualTo(String value) {
            addCriterion("shop_logo <=", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoLike(String value) {
            addCriterion("shop_logo like", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoNotLike(String value) {
            addCriterion("shop_logo not like", value, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoIn(List<String> values) {
            addCriterion("shop_logo in", values, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoNotIn(List<String> values) {
            addCriterion("shop_logo not in", values, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoBetween(String value1, String value2) {
            addCriterion("shop_logo between", value1, value2, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andShopLogoNotBetween(String value1, String value2) {
            addCriterion("shop_logo not between", value1, value2, "shopLogo");
            return (Criteria) this;
        }

        public Criteria andCouponStatusIsNull() {
            addCriterion("coupon_status is null");
            return (Criteria) this;
        }

        public Criteria andCouponStatusIsNotNull() {
            addCriterion("coupon_status is not null");
            return (Criteria) this;
        }

        public Criteria andCouponStatusEqualTo(Integer value) {
            addCriterion("coupon_status =", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusNotEqualTo(Integer value) {
            addCriterion("coupon_status <>", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusGreaterThan(Integer value) {
            addCriterion("coupon_status >", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon_status >=", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusLessThan(Integer value) {
            addCriterion("coupon_status <", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusLessThanOrEqualTo(Integer value) {
            addCriterion("coupon_status <=", value, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusIn(List<Integer> values) {
            addCriterion("coupon_status in", values, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusNotIn(List<Integer> values) {
            addCriterion("coupon_status not in", values, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusBetween(Integer value1, Integer value2) {
            addCriterion("coupon_status between", value1, value2, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon_status not between", value1, value2, "couponStatus");
            return (Criteria) this;
        }

        public Criteria andCouponIdIsNull() {
            addCriterion("coupon_id is null");
            return (Criteria) this;
        }

        public Criteria andCouponIdIsNotNull() {
            addCriterion("coupon_id is not null");
            return (Criteria) this;
        }

        public Criteria andCouponIdEqualTo(Integer value) {
            addCriterion("coupon_id =", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotEqualTo(Integer value) {
            addCriterion("coupon_id <>", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThan(Integer value) {
            addCriterion("coupon_id >", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupon_id >=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThan(Integer value) {
            addCriterion("coupon_id <", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThanOrEqualTo(Integer value) {
            addCriterion("coupon_id <=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdIn(List<Integer> values) {
            addCriterion("coupon_id in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotIn(List<Integer> values) {
            addCriterion("coupon_id not in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdBetween(Integer value1, Integer value2) {
            addCriterion("coupon_id between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotBetween(Integer value1, Integer value2) {
            addCriterion("coupon_id not between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponAmountIsNull() {
            addCriterion("coupon_amount is null");
            return (Criteria) this;
        }

        public Criteria andCouponAmountIsNotNull() {
            addCriterion("coupon_amount is not null");
            return (Criteria) this;
        }

        public Criteria andCouponAmountEqualTo(BigDecimal value) {
            addCriterion("coupon_amount =", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountNotEqualTo(BigDecimal value) {
            addCriterion("coupon_amount <>", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountGreaterThan(BigDecimal value) {
            addCriterion("coupon_amount >", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coupon_amount >=", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountLessThan(BigDecimal value) {
            addCriterion("coupon_amount <", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coupon_amount <=", value, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountIn(List<BigDecimal> values) {
            addCriterion("coupon_amount in", values, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountNotIn(List<BigDecimal> values) {
            addCriterion("coupon_amount not in", values, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coupon_amount between", value1, value2, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andCouponAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coupon_amount not between", value1, value2, "couponAmount");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIsNull() {
            addCriterion("freight_fee is null");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIsNotNull() {
            addCriterion("freight_fee is not null");
            return (Criteria) this;
        }

        public Criteria andFreightFeeEqualTo(BigDecimal value) {
            addCriterion("freight_fee =", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotEqualTo(BigDecimal value) {
            addCriterion("freight_fee <>", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeGreaterThan(BigDecimal value) {
            addCriterion("freight_fee >", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("freight_fee >=", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeLessThan(BigDecimal value) {
            addCriterion("freight_fee <", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("freight_fee <=", value, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeIn(List<BigDecimal> values) {
            addCriterion("freight_fee in", values, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotIn(List<BigDecimal> values) {
            addCriterion("freight_fee not in", values, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight_fee between", value1, value2, "freightFee");
            return (Criteria) this;
        }

        public Criteria andFreightFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight_fee not between", value1, value2, "freightFee");
            return (Criteria) this;
        }

        public Criteria andPayPriceIsNull() {
            addCriterion("pay_price is null");
            return (Criteria) this;
        }

        public Criteria andPayPriceIsNotNull() {
            addCriterion("pay_price is not null");
            return (Criteria) this;
        }

        public Criteria andPayPriceEqualTo(BigDecimal value) {
            addCriterion("pay_price =", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotEqualTo(BigDecimal value) {
            addCriterion("pay_price <>", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceGreaterThan(BigDecimal value) {
            addCriterion("pay_price >", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_price >=", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceLessThan(BigDecimal value) {
            addCriterion("pay_price <", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_price <=", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceIn(List<BigDecimal> values) {
            addCriterion("pay_price in", values, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotIn(List<BigDecimal> values) {
            addCriterion("pay_price not in", values, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_price between", value1, value2, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_price not between", value1, value2, "payPrice");
            return (Criteria) this;
        }

        public Criteria andRefundAmountIsNull() {
            addCriterion("refund_amount is null");
            return (Criteria) this;
        }

        public Criteria andRefundAmountIsNotNull() {
            addCriterion("refund_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRefundAmountEqualTo(BigDecimal value) {
            addCriterion("refund_amount =", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountNotEqualTo(BigDecimal value) {
            addCriterion("refund_amount <>", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountGreaterThan(BigDecimal value) {
            addCriterion("refund_amount >", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("refund_amount >=", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountLessThan(BigDecimal value) {
            addCriterion("refund_amount <", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("refund_amount <=", value, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountIn(List<BigDecimal> values) {
            addCriterion("refund_amount in", values, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountNotIn(List<BigDecimal> values) {
            addCriterion("refund_amount not in", values, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund_amount between", value1, value2, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andRefundAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund_amount not between", value1, value2, "refundAmount");
            return (Criteria) this;
        }

        public Criteria andBuyTimeIsNull() {
            addCriterion("buy_time is null");
            return (Criteria) this;
        }

        public Criteria andBuyTimeIsNotNull() {
            addCriterion("buy_time is not null");
            return (Criteria) this;
        }

        public Criteria andBuyTimeEqualTo(Date value) {
            addCriterion("buy_time =", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeNotEqualTo(Date value) {
            addCriterion("buy_time <>", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeGreaterThan(Date value) {
            addCriterion("buy_time >", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("buy_time >=", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeLessThan(Date value) {
            addCriterion("buy_time <", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeLessThanOrEqualTo(Date value) {
            addCriterion("buy_time <=", value, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeIn(List<Date> values) {
            addCriterion("buy_time in", values, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeNotIn(List<Date> values) {
            addCriterion("buy_time not in", values, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeBetween(Date value1, Date value2) {
            addCriterion("buy_time between", value1, value2, "buyTime");
            return (Criteria) this;
        }

        public Criteria andBuyTimeNotBetween(Date value1, Date value2) {
            addCriterion("buy_time not between", value1, value2, "buyTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNull() {
            addCriterion("delivery_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNotNull() {
            addCriterion("delivery_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualTo(Date value) {
            addCriterion("delivery_time =", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualTo(Date value) {
            addCriterion("delivery_time <>", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThan(Date value) {
            addCriterion("delivery_time >", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_time >=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThan(Date value) {
            addCriterion("delivery_time <", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_time <=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIn(List<Date> values) {
            addCriterion("delivery_time in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotIn(List<Date> values) {
            addCriterion("delivery_time not in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_time between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_time not between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNull() {
            addCriterion("pay_method is null");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNotNull() {
            addCriterion("pay_method is not null");
            return (Criteria) this;
        }

        public Criteria andPayMethodEqualTo(String value) {
            addCriterion("pay_method =", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotEqualTo(String value) {
            addCriterion("pay_method <>", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThan(String value) {
            addCriterion("pay_method >", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThanOrEqualTo(String value) {
            addCriterion("pay_method >=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThan(String value) {
            addCriterion("pay_method <", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThanOrEqualTo(String value) {
            addCriterion("pay_method <=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLike(String value) {
            addCriterion("pay_method like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotLike(String value) {
            addCriterion("pay_method not like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodIn(List<String> values) {
            addCriterion("pay_method in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotIn(List<String> values) {
            addCriterion("pay_method not in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodBetween(String value1, String value2) {
            addCriterion("pay_method between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotBetween(String value1, String value2) {
            addCriterion("pay_method not between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayChannelIsNull() {
            addCriterion("pay_channel is null");
            return (Criteria) this;
        }

        public Criteria andPayChannelIsNotNull() {
            addCriterion("pay_channel is not null");
            return (Criteria) this;
        }

        public Criteria andPayChannelEqualTo(String value) {
            addCriterion("pay_channel =", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotEqualTo(String value) {
            addCriterion("pay_channel <>", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelGreaterThan(String value) {
            addCriterion("pay_channel >", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelGreaterThanOrEqualTo(String value) {
            addCriterion("pay_channel >=", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLessThan(String value) {
            addCriterion("pay_channel <", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLessThanOrEqualTo(String value) {
            addCriterion("pay_channel <=", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelLike(String value) {
            addCriterion("pay_channel like", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotLike(String value) {
            addCriterion("pay_channel not like", value, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelIn(List<String> values) {
            addCriterion("pay_channel in", values, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotIn(List<String> values) {
            addCriterion("pay_channel not in", values, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelBetween(String value1, String value2) {
            addCriterion("pay_channel between", value1, value2, "payChannel");
            return (Criteria) this;
        }

        public Criteria andPayChannelNotBetween(String value1, String value2) {
            addCriterion("pay_channel not between", value1, value2, "payChannel");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIsNull() {
            addCriterion("commentStatus is null");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIsNotNull() {
            addCriterion("commentStatus is not null");
            return (Criteria) this;
        }

        public Criteria andCommentStatusEqualTo(Integer value) {
            addCriterion("commentStatus =", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotEqualTo(Integer value) {
            addCriterion("commentStatus <>", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusGreaterThan(Integer value) {
            addCriterion("commentStatus >", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("commentStatus >=", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusLessThan(Integer value) {
            addCriterion("commentStatus <", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusLessThanOrEqualTo(Integer value) {
            addCriterion("commentStatus <=", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIn(List<Integer> values) {
            addCriterion("commentStatus in", values, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotIn(List<Integer> values) {
            addCriterion("commentStatus not in", values, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusBetween(Integer value1, Integer value2) {
            addCriterion("commentStatus between", value1, value2, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("commentStatus not between", value1, value2, "commentStatus");
            return (Criteria) this;
        }


        public Criteria andRefundStatusIsNull() {
            addCriterion("refund_status is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("refund_status is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(Integer value) {
            addCriterion("refund_status =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(Integer value) {
            addCriterion("refund_status <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(Integer value) {
            addCriterion("refund_status >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("refund_status >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(Integer value) {
            addCriterion("refund_status <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(Integer value) {
            addCriterion("refund_status <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<Integer> values) {
            addCriterion("refund_status in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<Integer> values) {
            addCriterion("refund_status not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(Integer value1, Integer value2) {
            addCriterion("refund_status between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("refund_status not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andDelIndIsNull() {
            addCriterion("del_ind is null");
            return (Criteria) this;
        }

        public Criteria andDelIndIsNotNull() {
            addCriterion("del_ind is not null");
            return (Criteria) this;
        }

        public Criteria andDelIndEqualTo(Integer value) {
            addCriterion("del_ind =", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndNotEqualTo(Integer value) {
            addCriterion("del_ind <>", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndGreaterThan(Integer value) {
            addCriterion("del_ind >", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndGreaterThanOrEqualTo(Integer value) {
            addCriterion("del_ind >=", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndLessThan(Integer value) {
            addCriterion("del_ind <", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndLessThanOrEqualTo(Integer value) {
            addCriterion("del_ind <=", value, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndIn(List<Integer> values) {
            addCriterion("del_ind in", values, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndNotIn(List<Integer> values) {
            addCriterion("del_ind not in", values, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndBetween(Integer value1, Integer value2) {
            addCriterion("del_ind between", value1, value2, "delInd");
            return (Criteria) this;
        }

        public Criteria andDelIndNotBetween(Integer value1, Integer value2) {
            addCriterion("del_ind not between", value1, value2, "delInd");
            return (Criteria) this;
        }

        public Criteria andReceiveNameIsNull() {
            addCriterion("receive_name is null");
            return (Criteria) this;
        }

        public Criteria andReceiveNameIsNotNull() {
            addCriterion("receive_name is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveNameEqualTo(String value) {
            addCriterion("receive_name =", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameNotEqualTo(String value) {
            addCriterion("receive_name <>", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameGreaterThan(String value) {
            addCriterion("receive_name >", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameGreaterThanOrEqualTo(String value) {
            addCriterion("receive_name >=", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameLessThan(String value) {
            addCriterion("receive_name <", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameLessThanOrEqualTo(String value) {
            addCriterion("receive_name <=", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameLike(String value) {
            addCriterion("receive_name like", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameNotLike(String value) {
            addCriterion("receive_name not like", value, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameIn(List<String> values) {
            addCriterion("receive_name in", values, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameNotIn(List<String> values) {
            addCriterion("receive_name not in", values, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameBetween(String value1, String value2) {
            addCriterion("receive_name between", value1, value2, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceiveNameNotBetween(String value1, String value2) {
            addCriterion("receive_name not between", value1, value2, "receiveName");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneIsNull() {
            addCriterion("receive_phone is null");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneIsNotNull() {
            addCriterion("receive_phone is not null");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneEqualTo(String value) {
            addCriterion("receive_phone =", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneNotEqualTo(String value) {
            addCriterion("receive_phone <>", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneGreaterThan(String value) {
            addCriterion("receive_phone >", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("receive_phone >=", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneLessThan(String value) {
            addCriterion("receive_phone <", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneLessThanOrEqualTo(String value) {
            addCriterion("receive_phone <=", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneLike(String value) {
            addCriterion("receive_phone like", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneNotLike(String value) {
            addCriterion("receive_phone not like", value, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneIn(List<String> values) {
            addCriterion("receive_phone in", values, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneNotIn(List<String> values) {
            addCriterion("receive_phone not in", values, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneBetween(String value1, String value2) {
            addCriterion("receive_phone between", value1, value2, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneNotBetween(String value1, String value2) {
            addCriterion("receive_phone not between", value1, value2, "receivePhone");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXIsNull() {
            addCriterion("receive_phone_x is null");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXIsNotNull() {
            addCriterion("receive_phone_x is not null");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXEqualTo(String value) {
            addCriterion("receive_phone_x =", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXNotEqualTo(String value) {
            addCriterion("receive_phone_x <>", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXGreaterThan(String value) {
            addCriterion("receive_phone_x >", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXGreaterThanOrEqualTo(String value) {
            addCriterion("receive_phone_x >=", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXLessThan(String value) {
            addCriterion("receive_phone_x <", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXLessThanOrEqualTo(String value) {
            addCriterion("receive_phone_x <=", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXLike(String value) {
            addCriterion("receive_phone_x like", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXNotLike(String value) {
            addCriterion("receive_phone_x not like", value, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXIn(List<String> values) {
            addCriterion("receive_phone_x in", values, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXNotIn(List<String> values) {
            addCriterion("receive_phone_x not in", values, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXBetween(String value1, String value2) {
            addCriterion("receive_phone_x between", value1, value2, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceivePhoneXNotBetween(String value1, String value2) {
            addCriterion("receive_phone_x not between", value1, value2, "receivePhoneX");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressIsNull() {
            addCriterion("receive_address is null");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressIsNotNull() {
            addCriterion("receive_address is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressEqualTo(String value) {
            addCriterion("receive_address =", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressNotEqualTo(String value) {
            addCriterion("receive_address <>", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressGreaterThan(String value) {
            addCriterion("receive_address >", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressGreaterThanOrEqualTo(String value) {
            addCriterion("receive_address >=", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressLessThan(String value) {
            addCriterion("receive_address <", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressLessThanOrEqualTo(String value) {
            addCriterion("receive_address <=", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressLike(String value) {
            addCriterion("receive_address like", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressNotLike(String value) {
            addCriterion("receive_address not like", value, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressIn(List<String> values) {
            addCriterion("receive_address in", values, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressNotIn(List<String> values) {
            addCriterion("receive_address not in", values, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressBetween(String value1, String value2) {
            addCriterion("receive_address between", value1, value2, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveAddressNotBetween(String value1, String value2) {
            addCriterion("receive_address not between", value1, value2, "receiveAddress");
            return (Criteria) this;
        }

        public Criteria andReceiveLngIsNull() {
            addCriterion("receive_lng is null");
            return (Criteria) this;
        }

        public Criteria andReceiveLngIsNotNull() {
            addCriterion("receive_lng is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveLngEqualTo(String value) {
            addCriterion("receive_lng =", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngNotEqualTo(String value) {
            addCriterion("receive_lng <>", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngGreaterThan(String value) {
            addCriterion("receive_lng >", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngGreaterThanOrEqualTo(String value) {
            addCriterion("receive_lng >=", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngLessThan(String value) {
            addCriterion("receive_lng <", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngLessThanOrEqualTo(String value) {
            addCriterion("receive_lng <=", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngLike(String value) {
            addCriterion("receive_lng like", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngNotLike(String value) {
            addCriterion("receive_lng not like", value, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngIn(List<String> values) {
            addCriterion("receive_lng in", values, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngNotIn(List<String> values) {
            addCriterion("receive_lng not in", values, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngBetween(String value1, String value2) {
            addCriterion("receive_lng between", value1, value2, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLngNotBetween(String value1, String value2) {
            addCriterion("receive_lng not between", value1, value2, "receiveLng");
            return (Criteria) this;
        }

        public Criteria andReceiveLatIsNull() {
            addCriterion("receive_lat is null");
            return (Criteria) this;
        }

        public Criteria andReceiveLatIsNotNull() {
            addCriterion("receive_lat is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveLatEqualTo(String value) {
            addCriterion("receive_lat =", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatNotEqualTo(String value) {
            addCriterion("receive_lat <>", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatGreaterThan(String value) {
            addCriterion("receive_lat >", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatGreaterThanOrEqualTo(String value) {
            addCriterion("receive_lat >=", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatLessThan(String value) {
            addCriterion("receive_lat <", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatLessThanOrEqualTo(String value) {
            addCriterion("receive_lat <=", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatLike(String value) {
            addCriterion("receive_lat like", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatNotLike(String value) {
            addCriterion("receive_lat not like", value, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatIn(List<String> values) {
            addCriterion("receive_lat in", values, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatNotIn(List<String> values) {
            addCriterion("receive_lat not in", values, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatBetween(String value1, String value2) {
            addCriterion("receive_lat between", value1, value2, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveLatNotBetween(String value1, String value2) {
            addCriterion("receive_lat not between", value1, value2, "receiveLat");
            return (Criteria) this;
        }

        public Criteria andReceiveCityIsNull() {
            addCriterion("receive_city is null");
            return (Criteria) this;
        }

        public Criteria andReceiveCityIsNotNull() {
            addCriterion("receive_city is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveCityEqualTo(String value) {
            addCriterion("receive_city =", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityNotEqualTo(String value) {
            addCriterion("receive_city <>", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityGreaterThan(String value) {
            addCriterion("receive_city >", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityGreaterThanOrEqualTo(String value) {
            addCriterion("receive_city >=", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityLessThan(String value) {
            addCriterion("receive_city <", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityLessThanOrEqualTo(String value) {
            addCriterion("receive_city <=", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityLike(String value) {
            addCriterion("receive_city like", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityNotLike(String value) {
            addCriterion("receive_city not like", value, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityIn(List<String> values) {
            addCriterion("receive_city in", values, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityNotIn(List<String> values) {
            addCriterion("receive_city not in", values, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityBetween(String value1, String value2) {
            addCriterion("receive_city between", value1, value2, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andReceiveCityNotBetween(String value1, String value2) {
            addCriterion("receive_city not between", value1, value2, "receiveCity");
            return (Criteria) this;
        }

        public Criteria andSendNameIsNull() {
            addCriterion("send_name is null");
            return (Criteria) this;
        }

        public Criteria andSendNameIsNotNull() {
            addCriterion("send_name is not null");
            return (Criteria) this;
        }

        public Criteria andSendNameEqualTo(String value) {
            addCriterion("send_name =", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameNotEqualTo(String value) {
            addCriterion("send_name <>", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameGreaterThan(String value) {
            addCriterion("send_name >", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameGreaterThanOrEqualTo(String value) {
            addCriterion("send_name >=", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameLessThan(String value) {
            addCriterion("send_name <", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameLessThanOrEqualTo(String value) {
            addCriterion("send_name <=", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameLike(String value) {
            addCriterion("send_name like", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameNotLike(String value) {
            addCriterion("send_name not like", value, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameIn(List<String> values) {
            addCriterion("send_name in", values, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameNotIn(List<String> values) {
            addCriterion("send_name not in", values, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameBetween(String value1, String value2) {
            addCriterion("send_name between", value1, value2, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendNameNotBetween(String value1, String value2) {
            addCriterion("send_name not between", value1, value2, "sendName");
            return (Criteria) this;
        }

        public Criteria andSendPhoneIsNull() {
            addCriterion("send_phone is null");
            return (Criteria) this;
        }

        public Criteria andSendPhoneIsNotNull() {
            addCriterion("send_phone is not null");
            return (Criteria) this;
        }

        public Criteria andSendPhoneEqualTo(String value) {
            addCriterion("send_phone =", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneNotEqualTo(String value) {
            addCriterion("send_phone <>", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneGreaterThan(String value) {
            addCriterion("send_phone >", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("send_phone >=", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneLessThan(String value) {
            addCriterion("send_phone <", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneLessThanOrEqualTo(String value) {
            addCriterion("send_phone <=", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneLike(String value) {
            addCriterion("send_phone like", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneNotLike(String value) {
            addCriterion("send_phone not like", value, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneIn(List<String> values) {
            addCriterion("send_phone in", values, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneNotIn(List<String> values) {
            addCriterion("send_phone not in", values, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneBetween(String value1, String value2) {
            addCriterion("send_phone between", value1, value2, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneNotBetween(String value1, String value2) {
            addCriterion("send_phone not between", value1, value2, "sendPhone");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXIsNull() {
            addCriterion("send_phone_x is null");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXIsNotNull() {
            addCriterion("send_phone_x is not null");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXEqualTo(String value) {
            addCriterion("send_phone_x =", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXNotEqualTo(String value) {
            addCriterion("send_phone_x <>", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXGreaterThan(String value) {
            addCriterion("send_phone_x >", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXGreaterThanOrEqualTo(String value) {
            addCriterion("send_phone_x >=", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXLessThan(String value) {
            addCriterion("send_phone_x <", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXLessThanOrEqualTo(String value) {
            addCriterion("send_phone_x <=", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXLike(String value) {
            addCriterion("send_phone_x like", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXNotLike(String value) {
            addCriterion("send_phone_x not like", value, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXIn(List<String> values) {
            addCriterion("send_phone_x in", values, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXNotIn(List<String> values) {
            addCriterion("send_phone_x not in", values, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXBetween(String value1, String value2) {
            addCriterion("send_phone_x between", value1, value2, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendPhoneXNotBetween(String value1, String value2) {
            addCriterion("send_phone_x not between", value1, value2, "sendPhoneX");
            return (Criteria) this;
        }

        public Criteria andSendAddressIsNull() {
            addCriterion("send_address is null");
            return (Criteria) this;
        }

        public Criteria andSendAddressIsNotNull() {
            addCriterion("send_address is not null");
            return (Criteria) this;
        }

        public Criteria andSendAddressEqualTo(String value) {
            addCriterion("send_address =", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressNotEqualTo(String value) {
            addCriterion("send_address <>", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressGreaterThan(String value) {
            addCriterion("send_address >", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressGreaterThanOrEqualTo(String value) {
            addCriterion("send_address >=", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressLessThan(String value) {
            addCriterion("send_address <", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressLessThanOrEqualTo(String value) {
            addCriterion("send_address <=", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressLike(String value) {
            addCriterion("send_address like", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressNotLike(String value) {
            addCriterion("send_address not like", value, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressIn(List<String> values) {
            addCriterion("send_address in", values, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressNotIn(List<String> values) {
            addCriterion("send_address not in", values, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressBetween(String value1, String value2) {
            addCriterion("send_address between", value1, value2, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendAddressNotBetween(String value1, String value2) {
            addCriterion("send_address not between", value1, value2, "sendAddress");
            return (Criteria) this;
        }

        public Criteria andSendLngIsNull() {
            addCriterion("send_lng is null");
            return (Criteria) this;
        }

        public Criteria andSendLngIsNotNull() {
            addCriterion("send_lng is not null");
            return (Criteria) this;
        }

        public Criteria andSendLngEqualTo(String value) {
            addCriterion("send_lng =", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngNotEqualTo(String value) {
            addCriterion("send_lng <>", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngGreaterThan(String value) {
            addCriterion("send_lng >", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngGreaterThanOrEqualTo(String value) {
            addCriterion("send_lng >=", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngLessThan(String value) {
            addCriterion("send_lng <", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngLessThanOrEqualTo(String value) {
            addCriterion("send_lng <=", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngLike(String value) {
            addCriterion("send_lng like", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngNotLike(String value) {
            addCriterion("send_lng not like", value, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngIn(List<String> values) {
            addCriterion("send_lng in", values, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngNotIn(List<String> values) {
            addCriterion("send_lng not in", values, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngBetween(String value1, String value2) {
            addCriterion("send_lng between", value1, value2, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLngNotBetween(String value1, String value2) {
            addCriterion("send_lng not between", value1, value2, "sendLng");
            return (Criteria) this;
        }

        public Criteria andSendLatIsNull() {
            addCriterion("send_lat is null");
            return (Criteria) this;
        }

        public Criteria andSendLatIsNotNull() {
            addCriterion("send_lat is not null");
            return (Criteria) this;
        }

        public Criteria andSendLatEqualTo(String value) {
            addCriterion("send_lat =", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatNotEqualTo(String value) {
            addCriterion("send_lat <>", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatGreaterThan(String value) {
            addCriterion("send_lat >", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatGreaterThanOrEqualTo(String value) {
            addCriterion("send_lat >=", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatLessThan(String value) {
            addCriterion("send_lat <", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatLessThanOrEqualTo(String value) {
            addCriterion("send_lat <=", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatLike(String value) {
            addCriterion("send_lat like", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatNotLike(String value) {
            addCriterion("send_lat not like", value, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatIn(List<String> values) {
            addCriterion("send_lat in", values, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatNotIn(List<String> values) {
            addCriterion("send_lat not in", values, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatBetween(String value1, String value2) {
            addCriterion("send_lat between", value1, value2, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendLatNotBetween(String value1, String value2) {
            addCriterion("send_lat not between", value1, value2, "sendLat");
            return (Criteria) this;
        }

        public Criteria andSendCityIsNull() {
            addCriterion("send_city is null");
            return (Criteria) this;
        }

        public Criteria andSendCityIsNotNull() {
            addCriterion("send_city is not null");
            return (Criteria) this;
        }

        public Criteria andSendCityEqualTo(String value) {
            addCriterion("send_city =", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityNotEqualTo(String value) {
            addCriterion("send_city <>", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityGreaterThan(String value) {
            addCriterion("send_city >", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityGreaterThanOrEqualTo(String value) {
            addCriterion("send_city >=", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityLessThan(String value) {
            addCriterion("send_city <", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityLessThanOrEqualTo(String value) {
            addCriterion("send_city <=", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityLike(String value) {
            addCriterion("send_city like", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityNotLike(String value) {
            addCriterion("send_city not like", value, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityIn(List<String> values) {
            addCriterion("send_city in", values, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityNotIn(List<String> values) {
            addCriterion("send_city not in", values, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityBetween(String value1, String value2) {
            addCriterion("send_city between", value1, value2, "sendCity");
            return (Criteria) this;
        }

        public Criteria andSendCityNotBetween(String value1, String value2) {
            addCriterion("send_city not between", value1, value2, "sendCity");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIsNull() {
            addCriterion("invoice_status is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIsNotNull() {
            addCriterion("invoice_status is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusEqualTo(Integer value) {
            addCriterion("invoice_status =", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotEqualTo(Integer value) {
            addCriterion("invoice_status <>", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusGreaterThan(Integer value) {
            addCriterion("invoice_status >", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_status >=", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusLessThan(Integer value) {
            addCriterion("invoice_status <", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_status <=", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIn(List<Integer> values) {
            addCriterion("invoice_status in", values, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotIn(List<Integer> values) {
            addCriterion("invoice_status not in", values, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusBetween(Integer value1, Integer value2) {
            addCriterion("invoice_status between", value1, value2, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_status not between", value1, value2, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeIsNull() {
            addCriterion("pay_end_time is null");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeIsNotNull() {
            addCriterion("pay_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeEqualTo(Date value) {
            addCriterion("pay_end_time =", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeNotEqualTo(Date value) {
            addCriterion("pay_end_time <>", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeGreaterThan(Date value) {
            addCriterion("pay_end_time >", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_end_time >=", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeLessThan(Date value) {
            addCriterion("pay_end_time <", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_end_time <=", value, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeIn(List<Date> values) {
            addCriterion("pay_end_time in", values, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeNotIn(List<Date> values) {
            addCriterion("pay_end_time not in", values, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeBetween(Date value1, Date value2) {
            addCriterion("pay_end_time between", value1, value2, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andPayEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_end_time not between", value1, value2, "payEndTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeIsNull() {
            addCriterion("comment_expired_time is null");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeIsNotNull() {
            addCriterion("comment_expired_time is not null");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeEqualTo(Date value) {
            addCriterion("comment_expired_time =", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeNotEqualTo(Date value) {
            addCriterion("comment_expired_time <>", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeGreaterThan(Date value) {
            addCriterion("comment_expired_time >", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("comment_expired_time >=", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeLessThan(Date value) {
            addCriterion("comment_expired_time <", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeLessThanOrEqualTo(Date value) {
            addCriterion("comment_expired_time <=", value, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeIn(List<Date> values) {
            addCriterion("comment_expired_time in", values, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeNotIn(List<Date> values) {
            addCriterion("comment_expired_time not in", values, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeBetween(Date value1, Date value2) {
            addCriterion("comment_expired_time between", value1, value2, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andCommentExpiredTimeNotBetween(Date value1, Date value2) {
            addCriterion("comment_expired_time not between", value1, value2, "commentExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeIsNull() {
            addCriterion("finish_expired_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeIsNotNull() {
            addCriterion("finish_expired_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeEqualTo(Date value) {
            addCriterion("finish_expired_time =", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeNotEqualTo(Date value) {
            addCriterion("finish_expired_time <>", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeGreaterThan(Date value) {
            addCriterion("finish_expired_time >", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_expired_time >=", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeLessThan(Date value) {
            addCriterion("finish_expired_time <", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_expired_time <=", value, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeIn(List<Date> values) {
            addCriterion("finish_expired_time in", values, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeNotIn(List<Date> values) {
            addCriterion("finish_expired_time not in", values, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeBetween(Date value1, Date value2) {
            addCriterion("finish_expired_time between", value1, value2, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andFinishExpiredTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_expired_time not between", value1, value2, "finishExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeIsNull() {
            addCriterion("refund_expired_time is null");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeIsNotNull() {
            addCriterion("refund_expired_time is not null");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeEqualTo(Date value) {
            addCriterion("refund_expired_time =", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeNotEqualTo(Date value) {
            addCriterion("refund_expired_time <>", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeGreaterThan(Date value) {
            addCriterion("refund_expired_time >", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("refund_expired_time >=", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeLessThan(Date value) {
            addCriterion("refund_expired_time <", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeLessThanOrEqualTo(Date value) {
            addCriterion("refund_expired_time <=", value, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeIn(List<Date> values) {
            addCriterion("refund_expired_time in", values, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeNotIn(List<Date> values) {
            addCriterion("refund_expired_time not in", values, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeBetween(Date value1, Date value2) {
            addCriterion("refund_expired_time between", value1, value2, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andRefundExpiredTimeNotBetween(Date value1, Date value2) {
            addCriterion("refund_expired_time not between", value1, value2, "refundExpiredTime");
            return (Criteria) this;
        }

        public Criteria andNewOrOldIsNull() {
            addCriterion("new_or_old is null");
            return (Criteria) this;
        }

        public Criteria andNewOrOldIsNotNull() {
            addCriterion("new_or_old is not null");
            return (Criteria) this;
        }

        public Criteria andNewOrOldEqualTo(Integer value) {
            addCriterion("new_or_old =", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldNotEqualTo(Integer value) {
            addCriterion("new_or_old <>", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldGreaterThan(Integer value) {
            addCriterion("new_or_old >", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldGreaterThanOrEqualTo(Integer value) {
            addCriterion("new_or_old >=", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldLessThan(Integer value) {
            addCriterion("new_or_old <", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldLessThanOrEqualTo(Integer value) {
            addCriterion("new_or_old <=", value, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldIn(List<Integer> values) {
            addCriterion("new_or_old in", values, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldNotIn(List<Integer> values) {
            addCriterion("new_or_old not in", values, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldBetween(Integer value1, Integer value2) {
            addCriterion("new_or_old between", value1, value2, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andNewOrOldNotBetween(Integer value1, Integer value2) {
            addCriterion("new_or_old not between", value1, value2, "newOrOld");
            return (Criteria) this;
        }

        public Criteria andPetNumberIsNull() {
            addCriterion("pet_number is null");
            return (Criteria) this;
        }

        public Criteria andPetNumberIsNotNull() {
            addCriterion("pet_number is not null");
            return (Criteria) this;
        }

        public Criteria andPetNumberEqualTo(Integer value) {
            addCriterion("pet_number =", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberNotEqualTo(Integer value) {
            addCriterion("pet_number <>", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberGreaterThan(Integer value) {
            addCriterion("pet_number >", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("pet_number >=", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberLessThan(Integer value) {
            addCriterion("pet_number <", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberLessThanOrEqualTo(Integer value) {
            addCriterion("pet_number <=", value, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberIn(List<Integer> values) {
            addCriterion("pet_number in", values, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberNotIn(List<Integer> values) {
            addCriterion("pet_number not in", values, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberBetween(Integer value1, Integer value2) {
            addCriterion("pet_number between", value1, value2, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("pet_number not between", value1, value2, "petNumber");
            return (Criteria) this;
        }

        public Criteria andPetTypeIsNull() {
            addCriterion("pet_type is null");
            return (Criteria) this;
        }

        public Criteria andPetTypeIsNotNull() {
            addCriterion("pet_type is not null");
            return (Criteria) this;
        }

        public Criteria andPetTypeEqualTo(String value) {
            addCriterion("pet_type =", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeNotEqualTo(String value) {
            addCriterion("pet_type <>", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeGreaterThan(String value) {
            addCriterion("pet_type >", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeGreaterThanOrEqualTo(String value) {
            addCriterion("pet_type >=", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeLessThan(String value) {
            addCriterion("pet_type <", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeLessThanOrEqualTo(String value) {
            addCriterion("pet_type <=", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeLike(String value) {
            addCriterion("pet_type like", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeNotLike(String value) {
            addCriterion("pet_type not like", value, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeIn(List<String> values) {
            addCriterion("pet_type in", values, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeNotIn(List<String> values) {
            addCriterion("pet_type not in", values, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeBetween(String value1, String value2) {
            addCriterion("pet_type between", value1, value2, "petType");
            return (Criteria) this;
        }

        public Criteria andPetTypeNotBetween(String value1, String value2) {
            addCriterion("pet_type not between", value1, value2, "petType");
            return (Criteria) this;
        }

        public Criteria andPetVolumeIsNull() {
            addCriterion("pet_volume is null");
            return (Criteria) this;
        }

        public Criteria andPetVolumeIsNotNull() {
            addCriterion("pet_volume is not null");
            return (Criteria) this;
        }

        public Criteria andPetVolumeEqualTo(Integer value) {
            addCriterion("pet_volume =", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeNotEqualTo(Integer value) {
            addCriterion("pet_volume <>", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeGreaterThan(Integer value) {
            addCriterion("pet_volume >", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeGreaterThanOrEqualTo(Integer value) {
            addCriterion("pet_volume >=", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeLessThan(Integer value) {
            addCriterion("pet_volume <", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeLessThanOrEqualTo(Integer value) {
            addCriterion("pet_volume <=", value, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeIn(List<Integer> values) {
            addCriterion("pet_volume in", values, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeNotIn(List<Integer> values) {
            addCriterion("pet_volume not in", values, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeBetween(Integer value1, Integer value2) {
            addCriterion("pet_volume between", value1, value2, "petVolume");
            return (Criteria) this;
        }

        public Criteria andPetVolumeNotBetween(Integer value1, Integer value2) {
            addCriterion("pet_volume not between", value1, value2, "petVolume");
            return (Criteria) this;
        }

        public Criteria andLocateStatusIsNull() {
            addCriterion("locate_status is null");
            return (Criteria) this;
        }

        public Criteria andLocateStatusIsNotNull() {
            addCriterion("locate_status is not null");
            return (Criteria) this;
        }

        public Criteria andLocateStatusEqualTo(Integer value) {
            addCriterion("locate_status =", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusNotEqualTo(Integer value) {
            addCriterion("locate_status <>", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusGreaterThan(Integer value) {
            addCriterion("locate_status >", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("locate_status >=", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusLessThan(Integer value) {
            addCriterion("locate_status <", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusLessThanOrEqualTo(Integer value) {
            addCriterion("locate_status <=", value, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusIn(List<Integer> values) {
            addCriterion("locate_status in", values, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusNotIn(List<Integer> values) {
            addCriterion("locate_status not in", values, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusBetween(Integer value1, Integer value2) {
            addCriterion("locate_status between", value1, value2, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andLocateStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("locate_status not between", value1, value2, "locateStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusIsNull() {
            addCriterion("urgent_status is null");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusIsNotNull() {
            addCriterion("urgent_status is not null");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusEqualTo(Integer value) {
            addCriterion("urgent_status =", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusNotEqualTo(Integer value) {
            addCriterion("urgent_status <>", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusGreaterThan(Integer value) {
            addCriterion("urgent_status >", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("urgent_status >=", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusLessThan(Integer value) {
            addCriterion("urgent_status <", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusLessThanOrEqualTo(Integer value) {
            addCriterion("urgent_status <=", value, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusIn(List<Integer> values) {
            addCriterion("urgent_status in", values, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusNotIn(List<Integer> values) {
            addCriterion("urgent_status not in", values, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusBetween(Integer value1, Integer value2) {
            addCriterion("urgent_status between", value1, value2, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andUrgentStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("urgent_status not between", value1, value2, "urgentStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusIsNull() {
            addCriterion("insure_status is null");
            return (Criteria) this;
        }

        public Criteria andInsureStatusIsNotNull() {
            addCriterion("insure_status is not null");
            return (Criteria) this;
        }

        public Criteria andInsureStatusEqualTo(Integer value) {
            addCriterion("insure_status =", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusNotEqualTo(Integer value) {
            addCriterion("insure_status <>", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusGreaterThan(Integer value) {
            addCriterion("insure_status >", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("insure_status >=", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusLessThan(Integer value) {
            addCriterion("insure_status <", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusLessThanOrEqualTo(Integer value) {
            addCriterion("insure_status <=", value, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusIn(List<Integer> values) {
            addCriterion("insure_status in", values, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusNotIn(List<Integer> values) {
            addCriterion("insure_status not in", values, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusBetween(Integer value1, Integer value2) {
            addCriterion("insure_status between", value1, value2, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andInsureStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("insure_status not between", value1, value2, "insureStatus");
            return (Criteria) this;
        }

        public Criteria andJianyiCertIsNull() {
            addCriterion("jianyi_cert is null");
            return (Criteria) this;
        }

        public Criteria andJianyiCertIsNotNull() {
            addCriterion("jianyi_cert is not null");
            return (Criteria) this;
        }

        public Criteria andJianyiCertEqualTo(Integer value) {
            addCriterion("jianyi_cert =", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertNotEqualTo(Integer value) {
            addCriterion("jianyi_cert <>", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertGreaterThan(Integer value) {
            addCriterion("jianyi_cert >", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertGreaterThanOrEqualTo(Integer value) {
            addCriterion("jianyi_cert >=", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertLessThan(Integer value) {
            addCriterion("jianyi_cert <", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertLessThanOrEqualTo(Integer value) {
            addCriterion("jianyi_cert <=", value, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertIn(List<Integer> values) {
            addCriterion("jianyi_cert in", values, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertNotIn(List<Integer> values) {
            addCriterion("jianyi_cert not in", values, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertBetween(Integer value1, Integer value2) {
            addCriterion("jianyi_cert between", value1, value2, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andJianyiCertNotBetween(Integer value1, Integer value2) {
            addCriterion("jianyi_cert not between", value1, value2, "jianyiCert");
            return (Criteria) this;
        }

        public Criteria andProvideCageIsNull() {
            addCriterion("provide_cage is null");
            return (Criteria) this;
        }

        public Criteria andProvideCageIsNotNull() {
            addCriterion("provide_cage is not null");
            return (Criteria) this;
        }

        public Criteria andProvideCageEqualTo(Integer value) {
            addCriterion("provide_cage =", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageNotEqualTo(Integer value) {
            addCriterion("provide_cage <>", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageGreaterThan(Integer value) {
            addCriterion("provide_cage >", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageGreaterThanOrEqualTo(Integer value) {
            addCriterion("provide_cage >=", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageLessThan(Integer value) {
            addCriterion("provide_cage <", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageLessThanOrEqualTo(Integer value) {
            addCriterion("provide_cage <=", value, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageIn(List<Integer> values) {
            addCriterion("provide_cage in", values, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageNotIn(List<Integer> values) {
            addCriterion("provide_cage not in", values, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageBetween(Integer value1, Integer value2) {
            addCriterion("provide_cage between", value1, value2, "provideCage");
            return (Criteria) this;
        }

        public Criteria andProvideCageNotBetween(Integer value1, Integer value2) {
            addCriterion("provide_cage not between", value1, value2, "provideCage");
            return (Criteria) this;
        }

        public Criteria andCageSizeIsNull() {
            addCriterion("cage_size is null");
            return (Criteria) this;
        }

        public Criteria andCageSizeIsNotNull() {
            addCriterion("cage_size is not null");
            return (Criteria) this;
        }

        public Criteria andCageSizeEqualTo(Integer value) {
            addCriterion("cage_size =", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeNotEqualTo(Integer value) {
            addCriterion("cage_size <>", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeGreaterThan(Integer value) {
            addCriterion("cage_size >", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("cage_size >=", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeLessThan(Integer value) {
            addCriterion("cage_size <", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeLessThanOrEqualTo(Integer value) {
            addCriterion("cage_size <=", value, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeIn(List<Integer> values) {
            addCriterion("cage_size in", values, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeNotIn(List<Integer> values) {
            addCriterion("cage_size not in", values, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeBetween(Integer value1, Integer value2) {
            addCriterion("cage_size between", value1, value2, "cageSize");
            return (Criteria) this;
        }

        public Criteria andCageSizeNotBetween(Integer value1, Integer value2) {
            addCriterion("cage_size not between", value1, value2, "cageSize");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeIsNull() {
            addCriterion("expected_time is null");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeIsNotNull() {
            addCriterion("expected_time is not null");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeEqualTo(Date value) {
            addCriterion("expected_time =", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeNotEqualTo(Date value) {
            addCriterion("expected_time <>", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeGreaterThan(Date value) {
            addCriterion("expected_time >", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("expected_time >=", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeLessThan(Date value) {
            addCriterion("expected_time <", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeLessThanOrEqualTo(Date value) {
            addCriterion("expected_time <=", value, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeIn(List<Date> values) {
            addCriterion("expected_time in", values, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeNotIn(List<Date> values) {
            addCriterion("expected_time not in", values, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeBetween(Date value1, Date value2) {
            addCriterion("expected_time between", value1, value2, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andExpectedTimeNotBetween(Date value1, Date value2) {
            addCriterion("expected_time not between", value1, value2, "expectedTime");
            return (Criteria) this;
        }

        public Criteria andShuttleIsNull() {
            addCriterion("shuttle is null");
            return (Criteria) this;
        }

        public Criteria andShuttleIsNotNull() {
            addCriterion("shuttle is not null");
            return (Criteria) this;
        }

        public Criteria andShuttleEqualTo(String value) {
            addCriterion("shuttle =", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleNotEqualTo(String value) {
            addCriterion("shuttle <>", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleGreaterThan(String value) {
            addCriterion("shuttle >", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleGreaterThanOrEqualTo(String value) {
            addCriterion("shuttle >=", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleLessThan(String value) {
            addCriterion("shuttle <", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleLessThanOrEqualTo(String value) {
            addCriterion("shuttle <=", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleLike(String value) {
            addCriterion("shuttle like", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleNotLike(String value) {
            addCriterion("shuttle not like", value, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleIn(List<String> values) {
            addCriterion("shuttle in", values, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleNotIn(List<String> values) {
            addCriterion("shuttle not in", values, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleBetween(String value1, String value2) {
            addCriterion("shuttle between", value1, value2, "shuttle");
            return (Criteria) this;
        }

        public Criteria andShuttleNotBetween(String value1, String value2) {
            addCriterion("shuttle not between", value1, value2, "shuttle");
            return (Criteria) this;
        }

        public Criteria andHaulMethodIsNull() {
            addCriterion("haul_method is null");
            return (Criteria) this;
        }

        public Criteria andHaulMethodIsNotNull() {
            addCriterion("haul_method is not null");
            return (Criteria) this;
        }

        public Criteria andHaulMethodEqualTo(Byte value) {
            addCriterion("haul_method =", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodNotEqualTo(Byte value) {
            addCriterion("haul_method <>", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodGreaterThan(Byte value) {
            addCriterion("haul_method >", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodGreaterThanOrEqualTo(Byte value) {
            addCriterion("haul_method >=", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodLessThan(Byte value) {
            addCriterion("haul_method <", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodLessThanOrEqualTo(Byte value) {
            addCriterion("haul_method <=", value, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodIn(List<Byte> values) {
            addCriterion("haul_method in", values, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodNotIn(List<Byte> values) {
            addCriterion("haul_method not in", values, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodBetween(Byte value1, Byte value2) {
            addCriterion("haul_method between", value1, value2, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodNotBetween(Byte value1, Byte value2) {
            addCriterion("haul_method not between", value1, value2, "haulMethod");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmIsNull() {
            addCriterion("haul_method_confirm is null");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmIsNotNull() {
            addCriterion("haul_method_confirm is not null");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmEqualTo(Byte value) {
            addCriterion("haul_method_confirm =", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmNotEqualTo(Byte value) {
            addCriterion("haul_method_confirm <>", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmGreaterThan(Byte value) {
            addCriterion("haul_method_confirm >", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmGreaterThanOrEqualTo(Byte value) {
            addCriterion("haul_method_confirm >=", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmLessThan(Byte value) {
            addCriterion("haul_method_confirm <", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmLessThanOrEqualTo(Byte value) {
            addCriterion("haul_method_confirm <=", value, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmIn(List<Byte> values) {
            addCriterion("haul_method_confirm in", values, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmNotIn(List<Byte> values) {
            addCriterion("haul_method_confirm not in", values, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmBetween(Byte value1, Byte value2) {
            addCriterion("haul_method_confirm between", value1, value2, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andHaulMethodConfirmNotBetween(Byte value1, Byte value2) {
            addCriterion("haul_method_confirm not between", value1, value2, "haulMethodConfirm");
            return (Criteria) this;
        }

        public Criteria andPetPhotoIsNull() {
            addCriterion("pet_photo is null");
            return (Criteria) this;
        }

        public Criteria andPetPhotoIsNotNull() {
            addCriterion("pet_photo is not null");
            return (Criteria) this;
        }

        public Criteria andPetPhotoEqualTo(String value) {
            addCriterion("pet_photo =", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoNotEqualTo(String value) {
            addCriterion("pet_photo <>", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoGreaterThan(String value) {
            addCriterion("pet_photo >", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoGreaterThanOrEqualTo(String value) {
            addCriterion("pet_photo >=", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoLessThan(String value) {
            addCriterion("pet_photo <", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoLessThanOrEqualTo(String value) {
            addCriterion("pet_photo <=", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoLike(String value) {
            addCriterion("pet_photo like", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoNotLike(String value) {
            addCriterion("pet_photo not like", value, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoIn(List<String> values) {
            addCriterion("pet_photo in", values, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoNotIn(List<String> values) {
            addCriterion("pet_photo not in", values, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoBetween(String value1, String value2) {
            addCriterion("pet_photo between", value1, value2, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andPetPhotoNotBetween(String value1, String value2) {
            addCriterion("pet_photo not between", value1, value2, "petPhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoIsNull() {
            addCriterion("cage_photo is null");
            return (Criteria) this;
        }

        public Criteria andCagePhotoIsNotNull() {
            addCriterion("cage_photo is not null");
            return (Criteria) this;
        }

        public Criteria andCagePhotoEqualTo(String value) {
            addCriterion("cage_photo =", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoNotEqualTo(String value) {
            addCriterion("cage_photo <>", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoGreaterThan(String value) {
            addCriterion("cage_photo >", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoGreaterThanOrEqualTo(String value) {
            addCriterion("cage_photo >=", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoLessThan(String value) {
            addCriterion("cage_photo <", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoLessThanOrEqualTo(String value) {
            addCriterion("cage_photo <=", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoLike(String value) {
            addCriterion("cage_photo like", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoNotLike(String value) {
            addCriterion("cage_photo not like", value, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoIn(List<String> values) {
            addCriterion("cage_photo in", values, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoNotIn(List<String> values) {
            addCriterion("cage_photo not in", values, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoBetween(String value1, String value2) {
            addCriterion("cage_photo between", value1, value2, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andCagePhotoNotBetween(String value1, String value2) {
            addCriterion("cage_photo not between", value1, value2, "cagePhoto");
            return (Criteria) this;
        }

        public Criteria andMessageIsNull() {
            addCriterion("message is null");
            return (Criteria) this;
        }

        public Criteria andMessageIsNotNull() {
            addCriterion("message is not null");
            return (Criteria) this;
        }

        public Criteria andMessageEqualTo(String value) {
            addCriterion("message =", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageNotEqualTo(String value) {
            addCriterion("message <>", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageGreaterThan(String value) {
            addCriterion("message >", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageGreaterThanOrEqualTo(String value) {
            addCriterion("message >=", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageLessThan(String value) {
            addCriterion("message <", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageLessThanOrEqualTo(String value) {
            addCriterion("message <=", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageLike(String value) {
            addCriterion("message like", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageNotLike(String value) {
            addCriterion("message not like", value, "message");
            return (Criteria) this;
        }

        public Criteria andMessageIn(List<String> values) {
            addCriterion("message in", values, "message");
            return (Criteria) this;
        }

        public Criteria andMessageNotIn(List<String> values) {
            addCriterion("message not in", values, "message");
            return (Criteria) this;
        }

        public Criteria andMessageBetween(String value1, String value2) {
            addCriterion("message between", value1, value2, "message");
            return (Criteria) this;
        }

        public Criteria andMessageNotBetween(String value1, String value2) {
            addCriterion("message not between", value1, value2, "message");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(Date value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(Date value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(Date value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(Date value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<Date> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<Date> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(Date value1, Date value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddByIsNull() {
            addCriterion("add_by is null");
            return (Criteria) this;
        }

        public Criteria andAddByIsNotNull() {
            addCriterion("add_by is not null");
            return (Criteria) this;
        }

        public Criteria andAddByEqualTo(String value) {
            addCriterion("add_by =", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByNotEqualTo(String value) {
            addCriterion("add_by <>", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByGreaterThan(String value) {
            addCriterion("add_by >", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByGreaterThanOrEqualTo(String value) {
            addCriterion("add_by >=", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByLessThan(String value) {
            addCriterion("add_by <", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByLessThanOrEqualTo(String value) {
            addCriterion("add_by <=", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByLike(String value) {
            addCriterion("add_by like", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByNotLike(String value) {
            addCriterion("add_by not like", value, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByIn(List<String> values) {
            addCriterion("add_by in", values, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByNotIn(List<String> values) {
            addCriterion("add_by not in", values, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByBetween(String value1, String value2) {
            addCriterion("add_by between", value1, value2, "addBy");
            return (Criteria) this;
        }

        public Criteria andAddByNotBetween(String value1, String value2) {
            addCriterion("add_by not between", value1, value2, "addBy");
            return (Criteria) this;
        }

        public Criteria andUpdTimeIsNull() {
            addCriterion("upd_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdTimeIsNotNull() {
            addCriterion("upd_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdTimeEqualTo(Date value) {
            addCriterion("upd_time =", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeNotEqualTo(Date value) {
            addCriterion("upd_time <>", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeGreaterThan(Date value) {
            addCriterion("upd_time >", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("upd_time >=", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeLessThan(Date value) {
            addCriterion("upd_time <", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeLessThanOrEqualTo(Date value) {
            addCriterion("upd_time <=", value, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeIn(List<Date> values) {
            addCriterion("upd_time in", values, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeNotIn(List<Date> values) {
            addCriterion("upd_time not in", values, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeBetween(Date value1, Date value2) {
            addCriterion("upd_time between", value1, value2, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdTimeNotBetween(Date value1, Date value2) {
            addCriterion("upd_time not between", value1, value2, "updTime");
            return (Criteria) this;
        }

        public Criteria andUpdByIsNull() {
            addCriterion("upd_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdByIsNotNull() {
            addCriterion("upd_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdByEqualTo(String value) {
            addCriterion("upd_by =", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByNotEqualTo(String value) {
            addCriterion("upd_by <>", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByGreaterThan(String value) {
            addCriterion("upd_by >", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByGreaterThanOrEqualTo(String value) {
            addCriterion("upd_by >=", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByLessThan(String value) {
            addCriterion("upd_by <", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByLessThanOrEqualTo(String value) {
            addCriterion("upd_by <=", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByLike(String value) {
            addCriterion("upd_by like", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByNotLike(String value) {
            addCriterion("upd_by not like", value, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByIn(List<String> values) {
            addCriterion("upd_by in", values, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByNotIn(List<String> values) {
            addCriterion("upd_by not in", values, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByBetween(String value1, String value2) {
            addCriterion("upd_by between", value1, value2, "updBy");
            return (Criteria) this;
        }

        public Criteria andUpdByNotBetween(String value1, String value2) {
            addCriterion("upd_by not between", value1, value2, "updBy");
            return (Criteria) this;
        }

        public Criteria andLngIsNull() {
            addCriterion("lng is null");
            return (Criteria) this;
        }

        public Criteria andLngIsNotNull() {
            addCriterion("lng is not null");
            return (Criteria) this;
        }

        public Criteria andLngEqualTo(String value) {
            addCriterion("lng =", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotEqualTo(String value) {
            addCriterion("lng <>", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngGreaterThan(String value) {
            addCriterion("lng >", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngGreaterThanOrEqualTo(String value) {
            addCriterion("lng >=", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngLessThan(String value) {
            addCriterion("lng <", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngLessThanOrEqualTo(String value) {
            addCriterion("lng <=", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngLike(String value) {
            addCriterion("lng like", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotLike(String value) {
            addCriterion("lng not like", value, "lng");
            return (Criteria) this;
        }

        public Criteria andLngIn(List<String> values) {
            addCriterion("lng in", values, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotIn(List<String> values) {
            addCriterion("lng not in", values, "lng");
            return (Criteria) this;
        }

        public Criteria andLngBetween(String value1, String value2) {
            addCriterion("lng between", value1, value2, "lng");
            return (Criteria) this;
        }

        public Criteria andLngNotBetween(String value1, String value2) {
            addCriterion("lng not between", value1, value2, "lng");
            return (Criteria) this;
        }

        public Criteria andLatIsNull() {
            addCriterion("lat is null");
            return (Criteria) this;
        }

        public Criteria andLatIsNotNull() {
            addCriterion("lat is not null");
            return (Criteria) this;
        }

        public Criteria andLatEqualTo(String value) {
            addCriterion("lat =", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotEqualTo(String value) {
            addCriterion("lat <>", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatGreaterThan(String value) {
            addCriterion("lat >", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatGreaterThanOrEqualTo(String value) {
            addCriterion("lat >=", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatLessThan(String value) {
            addCriterion("lat <", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatLessThanOrEqualTo(String value) {
            addCriterion("lat <=", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatLike(String value) {
            addCriterion("lat like", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotLike(String value) {
            addCriterion("lat not like", value, "lat");
            return (Criteria) this;
        }

        public Criteria andLatIn(List<String> values) {
            addCriterion("lat in", values, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotIn(List<String> values) {
            addCriterion("lat not in", values, "lat");
            return (Criteria) this;
        }

        public Criteria andLatBetween(String value1, String value2) {
            addCriterion("lat between", value1, value2, "lat");
            return (Criteria) this;
        }

        public Criteria andLatNotBetween(String value1, String value2) {
            addCriterion("lat not between", value1, value2, "lat");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
